Dropping and recreating tables
Compose enable you to drop and recreate the Storage Zone tables as required.
When changing certain project settings (e.g. table prefixes) drop and create is required. If you change the Metadata after the Storage Zone tables and/or files were already created and loaded with data, you should adjust the Storage Zone to reflect the modified Metadata (as described in Validating the metadata and storage). Some changes however cannot be resolved by adjusting the Storage Zone. In such cases, you can either revert the Metadata to its pre-modified state or drop and (optionally) recreate the Storage Zone tables.
Note that dropping and recreating tables will delete all of the data in the tables and should only be performed in lieu of a better option.
-
In some scenarios, you need to edit the CREATE table statements before they are run. This can be done using the Generate DDL scripts but do not run them option in Project settings. For example, if you want to override the default sorting of your Storage Zone tables or add specific formatting annotations, you will need to edit the script to accomplish this.
- The Change Processing context (i.e. the point in time when changes were last captured) is deleted when dropping all tables but preserved when dropping selected tables. Therefore after deleting selected tables, in order for Compose to continue processing changes from when the tables were dropped, you need to perform the following additional steps:
- Duplicate the Full Load and Change Processing tasks.
- Delete the old tasks (i.e. the tasks that were duplicated) making sure to select the Delete mappings not used by other tasks option.
- Run the Full Load and Change Processing tasks again. This may result in duplicates in the Storage Zone tables, but the duplicates are excluded from the Storage Zone Views and will not appear in any provisioned data.
To drop and recreate all storage tables:
- In the Storage Zone panel, select the Drop and Recreate|Tables item from the menu in the top right corner.
- The Drop and Recreate Tables window opens.
- Select Recreate to drop and recreate the storage tables or Drop to drop them only.
-
Click OK to perform the drop and/or recreate operation.
The tables will be dropped and/or recreated, unless the Generate DDL scripts but do not run them option is enabled.